[dbo].[EventSetupGeneral]

Property	Value
Created	10:31:20 AM Tuesday, March 02, 2010
Last Modified	11:40:02 AM Monday, February 20, 2012

Property

Value

Created

10:31:20 AM Tuesday, March 02, 2010

Last Modified

11:40:02 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)
EventCode	varchar(15)	15
OnlineCutOffDate	datetime	8
OnlineCutOffMessage	varchar(256)	256
RegistrantClassType	varchar(24)	24
RegistrantClassStoredProcedure	varchar(64)	64
RegisterSomeoneElseOption	bit	1
PermanentChange	bit	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

EventCode

varchar(15)

OnlineCutOffDate

datetime

OnlineCutOffMessage

varchar(256)

256

RegistrantClassType

varchar(24)

RegistrantClassStoredProcedure

varchar(64)

RegisterSomeoneElseOption

bit

PermanentChange

bit

	Name	Columns	Unique
	PK_EventSetupGeneral	EventCode

Name

Columns

Unique

PK_EventSetupGeneral

EventCode

SQL Script

CREATE TABLE [dbo].[EventSetupGeneral]
(
[EventCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OnlineCutOffDate] [datetime] NOT NULL,
[OnlineCutOffMessage] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RegistrantClassType] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RegistrantClassStoredProcedure] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RegisterSomeoneElseOption] [bit] NOT NULL,
[PermanentChange] [bit] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[EventSetupGeneral] ADD CONSTRAINT [PK_EventSetupGeneral] PRIMARY KEY CLUSTERED ([EventCode]) ON [PRIMARY]
GO